R Notebook

This is an R Markdown Notebook. When you execute code within the notebook, the results appear beneath the code.

Try executing this chunk by clicking the Run button within the chunk or by placing your cursor inside it and pressing Cmd+Shift+Enter.

library(tidyverse)
library(readxl)
library(here)
library(janitor)

candy_2015 <- read_excel(here("raw_data/boing-boing-candy-2015.xlsx"))
candy_2016 <- read_excel(here("raw_data/boing-boing-candy-2016.xlsx"))
candy_2017 <- read_excel(here("raw_data/boing-boing-candy-2017.xlsx"))

New names:
* `` -> ...114

candy_2015 <- clean_names(candy_2015)
clean_names(candy_2016)

clean_names(candy_2017)

candy_2015_pivot <- candy_2015 %>%
    pivot_longer(c(butterfinger:york_peppermint_patties, necco_wafers),
                 names_to = "candy", values_to = "rating") %>%
    mutate(
        year = 2015,
        gender = NA,
        country = NA
    )%>%
rename(are_you_going_trick_or_treating = are_you_going_actually_going_trick_or_treating_yourself)%>%
rename(age = how_old_are_you)

removed_columns_candy_2015 <- select(candy_2015_pivot, -contains(c(
  "please",
  "guess_the_number",
  "that_dress",
  "fill_in",
  "betty",
  "which_day",
  "check_all",
  "if_you_squint",
  "sea_salt",
  "font")
))

glimpse(removed_columns_candy_2015)

Rows: 529,220
Columns: 8
$ timestamp                       <dttm> 2015-10-23 08:46:20, 2015-10-23 08:46:20, 2015-10-23 08:46:20, 2015-10-23 0…
$ age                             <chr> "35.0", "35.0", "35.0", "35.0", "35.0", "35.0", "35.0", "35.0", "35.0", "35.…
$ are_you_going_trick_or_treating <chr> "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No", "No"…
$ candy                           <chr> "butterfinger", "x100_grand_bar", "anonymous_brown_globs_that_come_in_black_…
$ rating                          <chr> "JOY", NA, "DESPAIR", "JOY", NA, NA, NA, NA, "DESPAIR", "DESPAIR", "DESPAIR"…
$ year                            <dbl> 2015, 2015, 2015, 2015, 2015, 2015, 2015, 2015, 2015, 2015, 2015, 2015, 2015…
$ gender                          <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, …
$ country                         <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, …